2014-03-13 -11858.100-Spec - Investigate Last PO price for Std Cost #FICOSupport

SPECIFICATIONS

11858.100-Spec- Investigate Last PO price for std cost

Purpose

To [[#|update]] the actual standard price in the Material Master based on the last PO price from the most recent Purchase Order for that material.

Admin Info

Purpose	Last PO price for std cost Update in the material master
Requested By	Jeff Mau
Spec Created By	Sai Valisetti
Spec Created Date	03/24/2014
Spec QA by	Jeff Mau
Objects
Document Status	Complated
Estimate (Hrs)	Analysis:40 hours ([[#\|complete]]) Config:1 hours Development: 32 Hours Unit Test: 26(functional) TOTAL: 99 Hours

References

Prior Tickets

Documents:

I have mentioned all the details in the document how the materials are costed and what sequence
Cost Estimate-NEC.doc

Functional Requirement

Normally the costing run captures the price J3AP from the condition record or [[#|purchase]] info record. This requirement is to calculate the standard cost estimate from the last changed price (J3AP)from the PO for selected materials.
Important points in the requirement:
1. Costing run should consider the [[#|latest]] PO price regardless of the vendor number that had the PO.
2. It should consider all the condition types J3AP,ZJ3S,ZOS0,ZOA1,ZGE0,ZPOH while calculating the material cost.
3. If the PO does not exists then it should revert to the old logic i.e Vendor condition record or info record.
4. The costing should be able to run for one material at a time that is inputed in CK11N (cost estimate for material) with a newly created costing variant (NEC4)
The attached document (Cost Estimate-NEC.doc) explains with screenshots (page11-12) how the change of PO price does not change value of the cost estimate presently

Solution Summary

[Discuss this section with Requester and get approval prior to beginning work]

A new costing variant NEC4 will be created for the exit ZXCKAU08 (which also uses NEC2 and NEC3) with the following logic:

If NEC4 is entered in CK11N, then the new logic should work to consider the [[#|latest]] PO price per the requirements listed above. if there is no latest PO price it should consider the old logic.. A sample screenshot is shown below:

Test Plan
[List test scenarios/cases to be executed here]

	Test Scenario	Expected Results
1	Test the latest PO with any vendor in different plants	Material should reflect latest PO price
2	Test if the PO does not exist	Material should reflect condition record/info record price
3	Test the old NEC2, NEC3	Material should NOT reflect latest PO price
4	Change condition record and test NEC4 with existing PO	Material should NOT reflect latest PO price
5	Change condition record and test NEC4 without existing PO	Material should reflect condition record/info record price
6	Change info record and test NEC4 with existing PO	Material should NOT reflect latest PO price
7	Change info record and test NEC4 without existing PO	Material should reflect condition record/info record price
8	If the Price is changed during the goods receipt	Material price reflect the latest price of the PO
9	If the all condition types prices are maintained	Condition type calculation based on the user exit calculation.

Solution Details

Configuration
NEC4 configuration should be as follows.

U Valuation Price with user Exit will trigger J3AP price can be carried out from the latest PO price if the PO price does not exists then it should calculate using condition record or Info record.
7 Valuation price according to the price control in material master will trigger only if the J3AP values are not maintained and standard or/and moving average values are maintained in the material master.
Standard Price: This [[#|[[#|step]]]] will never trigger as it will stop at step 2 as the step 2 is always [[#|valid]].
If none of the above steps are valid CK11N troughs error.

Technical

User Exit: ZXCKAU08

The requirement is to get J3AP price from Latest PO of the given Material and Plant when the Costing variant is 'NEC4'. Currently J3AP price is calculated based on Condition Type 'J3AP' from table KONP
-The current Formula For Cost Price = J3AP + ZOS0 + ZOA1 + ZGE0 + ZPOH + ZJ3S
-The New Formula for Cost Price = J3AP (PO) + ZOS0 + ZOA1 + ZGE0 + ZPOH + ZJ3S

If PO is not found for a material and plant ,

User Exit Should consider the Current Formula.

How to Get J3AP Price .

Fetch Latest PO from PO Item (EKPO) Table based on Given Material and Plant
Fetch Condition Document Number ( EKKI-KNUMV) from Purchasing Condition Index (EKKI) Table based on PO Number (EKPO-EBELN) and PO Item ( EKPO-EBELP)
Fetch Condition Price (KONV-KBETR) and Condition Price Unit(KONV-KMEIN) from Conditions (KONV) table based on Condition Doc Number ( EKKI-KNUMV) , PO Item ( EKPO-EBELP) and Condition Type ( J3AP).

If Condition Price Unit is 'EA'

Move Condition Price (KONV-KBETR) to J3AP Price

If Condition Price Unit not 'EA'

Convert Condition Price (KONV-KBETR) to 'EA' and move to J3AP Price.